Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
SerialNumber (FK)(PK) | A unique code, which can be either alpha, numeric or alpha-numeric, to identify an individual ITEM. | ID_NMB_SRZ | Name | varchar(40) | SerializedUnit(AS_UN_SRZ) |
ItemID (FK)(PK) | A unique system assigned identifier for the retailer's SKU. | ID_ITM | IdentityUUID | char(32) | SerializedUnit(AS_UN_SRZ) |
InventoryControlDocumentID (FK) | The reference number that uniquely identifies the InventoryControlDocument. | ID_ICD | Identity | integer | ICDMerchandiseLineItem(DO_LTM_ICD_MR) |
InventoryControlDocumentLineItemID (FK) | A unique system assigned identifier for the LineItem within the confines of the InventoryControlDocument. | IC_LTM_ICD | LineNumber | smallint | ICDMerchandiseLineItem(DO_LTM_ICD_MR) |